/********************************************************************
  Copyright by PCI, 2002-10-08
  File Name: db_ppm_offer_prod_rela_role.cxx
  Created Date: 2002-10-08 
  Author: Machine
  Version: 1.0 
  Last Version Date: 
  Version Date:
*******************************************************************/
/********************************************************************
  Copyright by PCI, 2002-10-08
  Class Name: CTable_PPM_OFFER_PROD_RELA_ROLE
  Created Date: 2002-10-08 
  Author: Machine
  Defined File: db_ppm_offer_prod_rela_role.hxx
  Last Version Date: 
  Version Date:
*******************************************************************/
#include "table_ppm.h"

CTable_PPM_OFFER_PROD_RELA_ROLE::CTable_PPM_OFFER_PROD_RELA_ROLE( )
 :NPCRecordSet( )
{
  setTableName( "PPM_OFFER_PROD_RELA_ROLE" );
  prepareTable();
  prepareQuery();
 
  ROLE_CD.setField( "ROLE_CD", DATA_DOUBLE, 22, 1 );
  makeTableItem( ROLE_CD );
  makeKeyItem( ROLE_CD ); 
  PARENT_ROLE_CD.setField( "PARENT_ROLE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( PARENT_ROLE_CD );
  ROLE_NAME.setField( "ROLE_NAME", DATA_CHAR, 500, 0 );
  makeTableItem( ROLE_NAME );
  ROLE_NUM_MAX.setField( "ROLE_NUM_MAX", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_NUM_MAX );
  ROLE_NUM_MIN.setField( "ROLE_NUM_MIN", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_NUM_MIN );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );

}


CTable_PPM_OFFER_PROD_RELA_ROLE::CTable_PPM_OFFER_PROD_RELA_ROLE( NPConnection& pcldb )
 :NPCRecordSet( pcldb )
{
  setTableName( "PPM_OFFER_PROD_RELA_ROLE" );
  prepareTable();
  prepareQuery();
 
  ROLE_CD.setField( "ROLE_CD", DATA_DOUBLE, 22, 1 );
  makeTableItem( ROLE_CD );
  makeKeyItem( ROLE_CD ); 
  PARENT_ROLE_CD.setField( "PARENT_ROLE_CD", DATA_DOUBLE, 22, 0 );
  makeTableItem( PARENT_ROLE_CD );
  ROLE_NAME.setField( "ROLE_NAME", DATA_CHAR, 500, 0 );
  makeTableItem( ROLE_NAME );
  ROLE_NUM_MAX.setField( "ROLE_NUM_MAX", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_NUM_MAX );
  ROLE_NUM_MIN.setField( "ROLE_NUM_MIN", DATA_DOUBLE, 22, 0 );
  makeTableItem( ROLE_NUM_MIN );
  STATE.setField( "STATE", DATA_CHAR, 6, 0 );
  makeTableItem( STATE );
  APP_ID.setField( "APP_ID", DATA_CHAR, 20, 0 );
  makeTableItem( APP_ID );
  APP_STATE.setField( "APP_STATE", DATA_CHAR, 20, 0 );
  makeTableItem( APP_STATE );
}

CTable_PPM_OFFER_PROD_RELA_ROLE::~CTable_PPM_OFFER_PROD_RELA_ROLE( )
{
    close();
}

